    create table "mydb"."dbo"."ROOMS"(
        "ROOM_NO" int not null,
       "ROOM_TYPE" varchar(30) not null,
       "INTERCOM_NO" numeric(10) not null,
       "PER_DAY_RENT" numeric(18) not null,
       "FLOOR_NO" numeric(18) not null,
       "PER_DAY_TAX" numeric(18) not null,
        constraint "ROOM_NO" primary key ("ROOM_NO")
    )
go

    create unique index "ROOM_NO" on "mydb"."dbo"."ROOMS"("ROOM_NO")
go

    create table "mydb"."dbo"."CHECK_IN_OUT_DETAILS"(
        "CHECK_IN_OUT_ID" int identity not null,
       "CHECK_IN_DATE_TIME" datetime not null,
       "CHECK_OUT_DATE_TIME" datetime not null,
       "NO_OF_DAYS" int not null,
        constraint "CHECK_IN_OUT_ID" primary key ("CHECK_IN_OUT_ID")
    )
go

    create unique index "CHECK_IN_OUT_ID" on "mydb"."dbo"."CHECK_IN_OUT_DETAILS"("CHECK_IN_OUT_ID")
go


